PostgreSQL Being Listed on Login Screen

Bug #1202054 reported by The Minder
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
accountsservice (Ubuntu)
Invalid
Undecided
Unassigned

Bug Description

First time bug raiser.

Reported this on Ubuntu forum here: http://ubuntuforums.org/showthread.php?t=2163070

Synopsis: 13.04 install DD 'cloned' to a new partition and apt-get dist-upgrade to 13.10. Logging in to the new 13.10 partition now lists PostgreSQL as a user which doesn't happen under 13.04.

Was requested to include lines from /etc/passwd:
wayne:x:1000:1000:wayne,,,:/home/wayne:/bin/bash
postgres:x:1001:1001:PostgreSQL:/etc/PostgreSQL/9.0:/bin/sh

ProblemType: Bug
DistroRelease: Ubuntu 13.10
Package: accountsservice 0.6.34-0ubuntu2
ProcVersionSignature: Ubuntu 3.10.0-3.12-generic 3.10.1
Uname: Linux 3.10.0-3-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.10.2-0ubuntu4
Architecture: amd64
Date: Wed Jul 17 12:27:35 2013
InstallationDate: Installed on 2013-04-14 (93 days ago)
InstallationMedia: Ubuntu 13.04 "Raring Ringtail" - Alpha amd64 (20130402.1)
MarkForUpload: True
SourcePackage: accountsservice
UpgradeStatus: No upgrade log present (probably fresh install)

Revision history for this message
The Minder (theminder) wrote :
Revision history for this message
Jeremy Bícha (jbicha) wrote :

How did you install PostgreSQL?

Revision history for this message
The Minder (theminder) wrote :

PostgreSQL v9.0 was downloaded from http://www.postgresql.org/ into the original 13.04 disto in my sda5. This was then DD cloned into my sda6 and dist-upgrade to 13.10. PostgreSQL is needed on my system as I run a Postgres database. It also has to be v9.0 as there are serious limitations to later versions. So, PostgreSQL is 'legitimate' on my system but has only started showing up as a 'user' since the upgrade to Saucy.

Sorry for the time delay, I'm UTC + 8.

Revision history for this message
Martin Pitt (pitti) wrote :

> postgres:x:1001:1001:PostgreSQL:/etc/PostgreSQL/9.0:/bin/sh

You created this yourself, didn't you? postgresql-common creates that user as a system user (uid < 500), but this is a "normal" (human) user. For system wide services you should rather do something like "sudo adduser --system postgres".

Changed in accountsservice (Ubuntu):
status: New → Invalid
Revision history for this message
The Minder (theminder) wrote :

@ Martin

I don't recall creating the "PostgreSQL" user... just installing the software. The software that creates and uses the PostgreSQL database creates it's own user.

Interestingly, if I go into Ubuntu's Users & Groups, the user 'PostgreSQL' is shown as disabled. The application PostgresSQL is right now happily running and managing my database.

Revision history for this message
The Minder (theminder) wrote :

Issue partially resolved.

The 13.04 installation I mentioned was actually cloned from a 12.04LTS partition and I recall that I had problems with permissions
that stopped PostgreSQL from running. The command to change the permissions of the PostgreSQL directory under /etc/ is:

"sudo chown -R postgres:postgres PostgreSQL"

and there's a good chance I screwed that up and inadvertently created a human level user called PostgreSQL. This also meant that I could not delete user PostgreSQL... even tho it was disabled.

I just corrected this (chown) error and have now managed to delete user PostgreSQL which no longer appears on the login screen or the logout/shutdown screen.

Nonetheless, that does not explain how the the 13.04 install did not list PostgreSQL user on the login screen whereas the 13.10 install did.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.